Jsp

推荐列表 站点导航

当前位置:首页 > 脚本编程 > Jsp >

JSP_将数据库中的数据通过client控件显示,有源代码,从浏览器到数据库关系:browser

来源:互联网  作者:网友投稿  发布时间:2021-01-12 10:11
将数据库中的数据通过client控件显示,有源代码,从浏览器到数据库关系:browser mschart controljavascript (client-side)ASP (se...

从浏览器到数据库关系:
browser
mschart control
javascript (client-side)
ASP (server-side vbscript)
ado
odbc
dbms
==================
关键在于将 RS 内的内容赋给 client-side javascript.
source code:
==================
<%@ LANGUAGE="VBSCRIPT" %>

           <%
                Dim oConn
                Dim oRs
                Dim curDir
                Dim Index


        Dim sqlstring
        sqlstring = "select field from table"

                ' Create ADO Connection Component to connect
                ' with sample database
                
                Set oConn = Server.CreateObject("ADODB.Connection")
                oConn.Open "DSN=localserver;SERVER=(local);UID=sa;PWD=;DATABASE=pubs"
                Set oRs = oConn.Execute(sqlstring)
           %>
           
           
           <script language=vbscript>
           
           <% Response.Write "<!--" %>
Sub Window_onload()
           Dim A
           A = Array(<%   
                Do while (Not oRs.eof) %>
                <%  =Int(oRs(0))%>,<%  oRs.MoveNext
                Loop
           %>0)


        MSChart1.ChartType = 1
        MSChart1.ChartData = A
        
End sub

           <% Response.Write "-->" %>
           </script>

           <%    
                oRs.close
                oConn.close
           %>


<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual InterDev 1.0">
<META HTTP-EQUIV="Content-Type" content="text/HTML; charset=iso-8859-1">
<TITLE>Document Title</TITLE>
</HEAD>
<BODY>

<!-- Insert HTML here -->

<OBJECT ID="MSChart1" WIDTH=356 HEIGHT=268
CLASSID="CLSID:31291E80-728C-11CF-93D5-0020AF99504A" CODEBASE="msChart.cab#version=5.0.37.14">
</OBJECT>

</BODY>
</HTML>&nbsp

本文作者:

相关热词:

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://v30.fanwenzhu.com/jiaob/jsp/12385.shtml

最新文章
热门文章
Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

JSP_将数据库中的数据通过client控件显示,有源代码,从浏览器到数据库关系:browser

2021-01-12 编辑:网友投稿

从浏览器到数据库关系:
browser
mschart control
javascript (client-side)
ASP (server-side vbscript)
ado
odbc
dbms
==================
关键在于将 RS 内的内容赋给 client-side javascript.
source code:
==================
<%@ LANGUAGE="VBSCRIPT" %>

           <%
                Dim oConn
                Dim oRs
                Dim curDir
                Dim Index


        Dim sqlstring
        sqlstring = "select field from table"

                ' Create ADO Connection Component to connect
                ' with sample database
                
                Set oConn = Server.CreateObject("ADODB.Connection")
                oConn.Open "DSN=localserver;SERVER=(local);UID=sa;PWD=;DATABASE=pubs"
                Set oRs = oConn.Execute(sqlstring)
           %>
           
           
           <script language=vbscript>
           
           <% Response.Write "<!--" %>
Sub Window_onload()
           Dim A
           A = Array(<%   
                Do while (Not oRs.eof) %>
                <%  =Int(oRs(0))%>,<%  oRs.MoveNext
                Loop
           %>0)


        MSChart1.ChartType = 1
        MSChart1.ChartData = A
        
End sub

           <% Response.Write "-->" %>
           </script>

           <%    
                oRs.close
                oConn.close
           %>


<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual InterDev 1.0">
<META HTTP-EQUIV="Content-Type" content="text/HTML; charset=iso-8859-1">
<TITLE>Document Title</TITLE>
</HEAD>
<BODY>

<!-- Insert HTML here -->

<OBJECT ID="MSChart1" WIDTH=356 HEIGHT=268
CLASSID="CLSID:31291E80-728C-11CF-93D5-0020AF99504A" CODEBASE="msChart.cab#version=5.0.37.14">
</OBJECT>

</BODY>
</HTML>&nbsp

本文作者:

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://v30.fanwenzhu.com/jiaob/jsp/12385.shtml

相关文章

风云图片

推荐阅读

返回Jsp频道首页